Search Results

Search found 5 results on 1 pages for 'needshelp'.

Page 1/1 | 1 

• SQL Where question

  - by needshelp

  Hi all, I have a question about case statements and nulls in a where clause. I want to do the following: Declare @someVar int = null select column1 from TestTable t where t = case when @someVar is not null then @someVar else t end Here is the problem: Let's say @someVar is null. Let's also say that column1 from TestTable t has NULL column values. Then, my condition t = t in the case statement will always evaluate to false. I basically just want to be able to conditionally filter the column based on the value of @someVar if it's provided. Any help?

  Read the article

• ExtJS Portal - Columns of different sizes

  - by needshelp

  I need to be able to use different size columns in the ExtJS portal. For example, I want in the center region, one area which has room for one big widget, and then right below it, 2 areas for 2 smaller widgets. I keep trying to play with the columns to figure this out, but nothing seems to work. Help?

  Read the article

• Union and If Exists - not working together - Please help

  - by needshelp

  I need to get dummy values if they do no rows returned from table. The If exists works by itself, but gives error with a Union. Can someone please guide me with a solution or a workaround? create table test1 (col1 varchar(10)) create table test2 (col1 varchar(10)) create table test3 (col1 varchar(10)) insert test1 values ('test1-row1') insert test1 values ('test1-row2') insert test2 values ('test2-row1') insert test2 values ('test2-row2') select col1 from test1 union select col1 from test2 union if exists (select * from test3) select col1 from test3 else select 'dummy'

  Read the article

• Check file stamp using FTP to see if it is today's file.

  - by needshelp

  Hi, I am using FTP (plain version) to download files from a server. The name of the file is always the same. All I can do to check to know if it is today's file is look at the timestamp manually. How can I write FTP script to check if the time stamp is having today's date? If you have come across this situation and have solved it, please let me know. Thank you in advance for your time.

  Read the article

• SSIS package in SQL Server 2005 can send data to SQL Server 2008?

  - by needshelp

  Hi SSIS Geniuses, I Have an SSIS package in SQL Server 2005 that takes data from a flat file and puts it in a table in SQL Server 2005. Now I want it to send it to an additional location along with the 2005 location. This new table is in SQL Server 2008. Can it be done without porting my SSIS package to SQL Server 2008? Thank you for your help in advance.

  Read the article

1