No announcements
Found 172686 threads
-
0 VotesTrouble with IF Statements
I have multiple tables in the database and I feel like I should have a table reference in there, but I cannot seem to insert a from statement anywhere in it without getting other errors.Answered | 1 Replies | 6454 Views | Created by obyrne11a - Friday, September 11, 2009 2:21 PM | Last reply by Bikash Dash - Friday, September 11, 2009 3:43 PM
-
1 Votes
Trouble with PowerShell IF statements
Processes over 100MB" Write-Output "=====================================" get-process | where-object {$_.pm -gt 100000000} | ...Answered | 10 Replies | 1676 Views | Created by Ashley baldwin - Friday, January 22, 2016 8:49 AM | Last reply by jrv - Friday, January 22, 2016 4:50 PM -
1 Votes
having trouble with a sql SP statement
0 AND st_desc LIKE '%FREIGHT') THEN st_desc ELSE st_desc END) AS ...Answered | 12 Replies | 943 Views | Created by cojimarmiami - Friday, March 28, 2014 2:47 PM | Last reply by Visakh16 - Saturday, March 29, 2014 6:25 AM -
0 Votes
Trouble Using the Replace command in select statement
I am trying to use the REPLACE command in a select statement, but I am having trouble.Answered | 6 Replies | 4125 Views | Created by DeveloperNoobie - Monday, March 29, 2010 12:20 PM | Last reply by dougieday - Monday, March 29, 2010 9:56 PM -
0 Votes
Trouble using an or statement with a boolean value
1 : 0 - this will work for just one column however as soon as I add a new column with an | | statement it ...Answered | 3 Replies | 790 Views | Created by Pauly555 - Tuesday, June 7, 2016 8:11 PM | Last reply by jandho - Tuesday, June 14, 2016 8:48 AM -
0 Votes
Trouble with an IF statement that uses a bit datatype
In this statement the field "TUpdate" is a bit. 0=False, 1=True.Answered | 1 Replies | 5393 Views | Created by LRHM123 - Thursday, November 18, 2010 12:11 PM | Last reply by ramireddy - Thursday, November 18, 2010 12:20 PM -
0 Votes
Trouble using a stored procedure in THEN clause of a CASE statement
We have CASE Expression in MS SQL Server not CASE Statements.Answered | 4 Replies | 3778 Views | Created by Chris A Lundgren - Thursday, November 3, 2011 4:03 PM | Last reply by Chris A Lundgren - Friday, November 4, 2011 1:30 PM -
0 Votes
SQL Statement Troubles
OK, this should pretty easy, but I can't locate any examples of what I need to save my life!! Let's say I have data that looks like the table below. I am trying to count the number of DISTINCT ...Answered | 11 Replies | 1150 Views | Created by HarleyHetz - Monday, November 18, 2013 6:50 PM | Last reply by HarleyHetz - Friday, November 22, 2013 7:01 PM -
0 Votes
Trouble w/ using SWITCH statement w/ partitions
Anyway, the syntax of the "alter table" statement is not correct.Answered | 2 Replies | 10058 Views | Created by Robert Carin - Tuesday, May 25, 2010 3:19 PM | Last reply by Robert Carin - Tuesday, May 25, 2010 10:23 PM -
0 Votes
Having trouble with the syntax on a SWITCH / IIF statement
Now I'm getting a different error: The Value expression for the textrun ‘ResourceDesc1.Paragraphs[0].TextRuns[2]’ contains an error: [BC30205] ...Answered | 10 Replies | 952 Views | Created by BRStewart - Thursday, January 9, 2020 5:02 PM | Last reply by Guoxiong Yuan - Tuesday, January 14, 2020 5:09 PM -
0 Votes
Having trouble converting a MS Access IIF statement into SQL Sever 2012
The statement that works in MS Access currently right now is IIf([$$AMTP46 WITH LAST DRG]!Answered | 2 Replies | 619 Views | Created by SmithBrianScott - Friday, February 20, 2015 4:17 PM | Last reply by Jingyang Li - Friday, February 20, 2015 5:12 PM -
0 Votes
If Statements with MERGEFIELD
Hi Paul, I think I can manage different logic now, but I am still having some trouble with syntax and location of TABLESTART and TABLEEND.Answered | 4 Replies | 2875 Views | Created by WordTrouble - Tuesday, February 9, 2016 4:54 AM | Last reply by macropod - Tuesday, February 9, 2016 10:01 PM -
1 Votes
Having some trouble with my switch statement
I am fairly new to powershell. I am trying to generate a report of all of the computer in an OU that have not upgraded. This is what I have. $OUTOFDATECOMPUTERS ...Answered | 2 Replies | 404 Views | Created by GrumpyKnight - Wednesday, November 15, 2017 8:57 PM | Last reply by GrumpyKnight - Thursday, November 16, 2017 2:30 PM -
2 Votes
problem with CASE Statement Syntax
If process type = 'Manual' Then CASE STATEMENT A ELSE CASE STATEMENT B End ...Answered | 8 Replies | 2715 Views | Created by R_i-c_h - Tuesday, November 6, 2012 3:40 PM | Last reply by R_i-c_h - Tuesday, November 6, 2012 5:22 PM -
0 Votes
If statement
If you want the second condition to only get checked if the first failed, you need to nest the if ...Answered | 4 Replies | 4424 Views | Created by Mike Lora - Thursday, November 18, 2010 4:51 PM | Last reply by Naomi N - Thursday, November 18, 2010 5:39 PM -
0 Votes
IF STATEMENT
I have written a peice of code that evaluates a two variables and I need to confirm that when once an if statement has been satisfied will the else if statement be ...Answered | 4 Replies | 2141 Views | Created by BlackIceProject - Wednesday, December 26, 2012 11:09 AM | Last reply by --CELKO-- - Wednesday, December 26, 2012 3:07 PM -
0 Votes
CASE statement in a JOIN\UPDATE statement
You can combine these two using a CASE statement as shown below.Answered | 1 Replies | 1289 Views | Created by edm2 - Thursday, September 19, 2013 1:58 AM | Last reply by cruellogic - Thursday, September 19, 2013 3:07 AM -
0 Votes
SQL Server Query trouble.
This includes table DDL and sample data INSERT statements.Answered | 4 Replies | 1261 Views | Created by Ted Dibiase - Tuesday, October 1, 2013 10:13 PM | Last reply by Allen Li - MSFT - Tuesday, October 8, 2013 8:43 AM -
0 Votes
Nested Where statements?
Perhaps using a case statement like this: SELECT t1.Answered | 2 Replies | 4938 Views | Created by nthompson - Wednesday, February 24, 2010 5:04 PM | Last reply by J M - Thursday, February 25, 2010 5:53 AM -
1 Votes
CASE statement, IF statement, or something else?
CASE is an expression and not a statement.Answered | 3 Replies | 2447 Views | Created by battlFrog - Wednesday, June 13, 2012 8:52 PM | Last reply by --CELKO-- - Wednesday, June 13, 2012 9:34 PM - Items 1 to 20 of 172686 Next ›
No announcements
