Topics
Started by
Posts
Last post
Hi, I have 2 table with one-to-many relationship Table1 ID Value1 Value2 .... 1 a b …
4 replies
Hi Frends I have been asked to calculate the Rolling avg for a set of data Here is my sample data …
1 replies
Hello, I'm trying to write a report to show end of day bank balances over a period, but the table o…
11 replies
Hello folks, My company has recently migrated some of our apps from SS2K to SS2K5, and we have noti…
12 replies
What will be the appropriate datatypes for following Username Machinename Executionstarttime Packag…
9 replies
I have: test.deleteflag ('Y' or 'N') test.deletedate When someone updates test.deleteflag to 'Y', …
10 replies
I have some fairly complex views and want to display the definition of the view columns in some way…
1 replies
I am trying to get distinct counts on forms a certain user has filed for a certain day. I am using …
3 replies
I'm working on a table called "GroupingTest", shown below. myIDmyNamemyMoney 1manny12.00 3moe…
9 replies
I need a simple sql statement with a case to determine whether 2 times need to be added or subtract…
7 replies
Has anyone ever figured out a way to commit a certain number of rows in a select statement. I alw…
4 replies
Greetings, Have just moved to Microsoft SQL Server 2005. Am starting to learn T-SQL. But I have a…
9 replies
I have a script that works in versions. example if @i = 1 BEGIN END if @i = 2 BEGIN END in a block …
4 replies
Hi, When you try this code: DECLARE @a BIGINT SET @a = POWER(2,30) PRINT @a you get: 1073741824 Whe…
4 replies
Hi, Server: Msg 8152, Level 16, State 4, Line 1 String or binary data would be truncated. The state…
2 replies
Viewing 15 topics - 8,041 through 8,055 (of 12,234 total)
You must be logged in to create new topics.